﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Maticsoft.DBUtility;
using System.Data.SqlClient;
using System.Data;

namespace BDCS.DAL
{
  public  class GetBuildAttributes
    {
      public DataSet GetList(string strWhere)
      {
          StringBuilder strSql = new StringBuilder();
          strSql.Append("select a.BTName,b.SBTName,c.SBAContent,c.SBADescribe,d.SAContent,d.SADescribe,d.SAID ");
          strSql.Append("From T_BuildTyppes  as a inner join T_SubBuildTyppes as b  on a.BTID=b.BTID inner join T_SubBuildAttributes  as c on b.SBTID=c.SBTID  inner join T_SubAttributes as d on c.SBAID=d.SBAID ");
          if (strWhere.Trim() != "")
          {
              strSql.Append(" where " + strWhere);
          }
          return DbHelperSQL.Query(strSql.ToString());
      }
    }
}
